valign pada table di asp.net core

<td style="vertical-align: middle">Test</td>

vertical-align : middle = valign="center"

Menampilkan angka dengan belakang koma di Asp.Net Core

double CPLPersen= 30.10;

TempData["CPLPersen"] = CPLPersen.ToString("#,##0.00"); 

iif dalam MS-SQL

perintah IIF dalam MS-SQL

select iif(praktikum is null,'Kuliah','Praktikum')  as jenisKuliah from kuliah

artinya jika field berisi null maka jenisKuliah berisi kata Kuliah, sebaliknya jika tidak null maka berisi Praktikum

MySQL di ASP.Net Core

Install NuGet

Project - Manage NuGet

MySQL Data (Install)

Test Koneksi

using MySql.Data.MySqlClient;

MySql.Data.MySqlClient.MySqlConnection myConnection;

string myConnectionString;

myConnectionString = "server=server;uid=user;pwd=password;database=database";

try

{

    myConnection = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);

    myConnection.Open();

    MySqlCommand myCommand = new MySqlCommand();

    myCommand.Connection = myConnection;

    myCommand.CommandText = @"SELECT * FROM GudangWHERE field = @param;";

    myCommand.Parameters.AddWithValue("@param", "123445");

    using var myReader = myCommand.ExecuteReader();

    {

        while (myReader.Read())

        {

            TempData["Nama"]= myReader.GetString("nama");

        }

    }

    myConnection.Close();

}

catch (MySql.Data.MySqlClient.MySqlException ex)

{

    TempData["Nama"]= ex.Message;

}

UNIQUEIDENTIFIER With DEFAULT

 ALTER TABLE tabel123

  ADD NewColumn1 UNIQUEIDENTIFIER

  CONSTRAINT DF_T_Account_NewColumn1 DEFAULT (newid()) WITH VALUES